How to: Add a text field in a table.
Solution:
In the Table Design view, insert the field, type a field name, and select 'Text' from the drop-down list in the 'Data Type' column.
1) If the Database window is not active, activate the Database window.
2) Open the table's Design view.
3) Do one of the following to add a field to the table:
a) To add the field to the end of the table, click in the first blank row.
b) To insert a field within the table:
1] Click in the row above which the field is to be added.
2] Select the 'Insert' menu and select 'Field'. (The row appears above the selected row.)
4) Type a name for the field in the 'Field Name' column.
5) Click in the 'Data Type' column. (A down-arrow appears.)
6) Click on the arrow in the 'Data Type' column. (A drop-down list appears.)
7) Select 'Text' from the 'Data Type' drop-down list.
Text
8) (Optional) Set field properties for the added field:
a) Move to the 'Field Properties' section.
Field Properties section
b) Click the 'General' tab.
c) Make the desired entries and selections.
d) Click the 'Lookup' tab.
e) Click in the 'Display Control' field. (A down arrow appears.)
f) Click on the arrow in the 'Display Control' field. (A drop-down list appears.)
g) Select the desired control for the text box from the 'Display Control' drop-down list.
NOTE: The selections are 'Text Box', 'List Box', and 'Combo Box'.
h) (Special Case) If either 'List Box' or 'Combo Box' is selected in step 8)g), make the desired selections and entries in the additional properties that appear for the 'Lookup' tab.
9) Select the 'File' menu and select 'Save'.
10) Select the 'File' menu and select 'Close' when finished making changes in the Table Design window.
